2017-04-12 - 25851 - Break Fix - Exclude Intercompany Customer 1021431 #BExQueriesforCrystalReportsAnalysisTool

Break Fix

25851 - Exclude Intercompany Customers

Problem Summary

Need to exclude Intercompany Customers from all Global & Regional BEx Queries.

Admin Info

Purpose	Need to exclude Intercompany Customers from all Global & Regional BEx Queries.
Requested by	Saravanan Lakshmanan
Issue Date	04-12-2017
Resolved by	Uday Kumar P
Resolved Date	04-12-2017
Document Status	Complete

Detailed Problem Description

Need to exclude Intercompany Customer 1021431 from all Global & Regional BEx Queries. The additional list of intercompany customers that need to be excluded are attached here for reference.

Solution Analysis and Recommendations

1. Need to create an open BEx transport request in BPD.
2. Need to exclude new Retail & Intercompany Customers for 0CUSTOMER (or) 0SOLD_TO info objects in the BEx filter section.
3. Need to collect all the queries for an infoprovider into one open transport request.
4. Need to transport it to BPQ for testing and move it to BPP after successful testing.
5. Need to exclude the above customers manually in OSA100 and OSA180 Global and regional reports.

Resolution

1. Created an Open transport request in BPD(BW 7.3 Development).
2. Excluded new Retail & Intercompany Customers 1021431 for 0CUSTOMER (or) 0SOLD_TO info objects in the BEx filter section.
3. Collected all the queries for an infoprovider into the open transport request.
4. Transported it to BPQ(BW 7.3 Quality) for testing and moved it to BPP(BW 7.3 Production) after successful testing.
5. The list of all BEx Queries in which Retail and Intercompany customers are excluded or included are attached here for reference:

InterCompany Customers.txt
Global BEx Queries for exclusion.xls
Regional BEx Queries for Exclusion.xlsx